package com.housekeeping.housekeeping.serviceTest.dao;/*
 * @author  pyh
 * @date  2021/1/22 0022 下午 3:04
 * @version 1.0
 * @since JDK1.8_241
 */

import com.housekeeping.housekeeping.advertisingmanagement.entity.AdMessages;
import com.housekeeping.housekeeping.serviceTest.entity.Orders;

import java.sql.SQLException;
import java.util.List;

public interface OrderTestDao {
    //分页查询
    List<Orders> getPagesList(int currentPage,int pageSize) throws SQLException;
    // 查询总条数
    int getTotalCount() throws SQLException;
    // 查询订单记录
    Orders getOrderContent(String id) throws SQLException;
    // 通过支付状态查询对应状态的订单
    List<Orders> getStatusList(int status,int page,int size) throws SQLException;
    // 获取支付状态查询对应状态的订单的总条数（用于前端的分页查询）
    int getStatusCount(int status) throws SQLException;
    // 通过【手机号】和【支付状态】查询对应的订单
    List<Orders> getPhonesList(String phone,int status,int page,int size) throws SQLException;
    // 通过【手机号】和【支付状态】查询对应的订单的总条数（用于前端分页）
    int getStatusAndPhoneCount(int status,String phone) throws SQLException;
}
